BEGIN TRANSACTION
GO
ALTER TABLE dbo.Voucher ADD
	BankDate varchar(100) NULL,
	BankRef varchar(100) NULL,
	Remit numeric(13, 2) NOT NULL CONSTRAINT DF_Voucher_Remit DEFAULT 0
GO
COMMIT

----------------------------------------------------------------

UPDATE    Voucher
SET              Remit = NetInvoice
----------------------------------------------------------------